Definition: Data source filtering in Tableau is the process of restricting the data available from a data source before it is used for analysis in worksheets and dashboards. It helps control which records are included in the analysis, reduce unnecessary data, improve performance in suitable scenarios, and provide a consistent subset of data across workbook views.
Example: A company has sales data for India, the USA, the UK, and Canada. If the report should contain only Indian sales, a data source filter can restrict the data to the India region.
Course: JustAcademy Tableau Training
Course Demo: Register for a Tableau Course Demo
A data source filter is a filter applied to a Tableau data source. It limits the records available to analyses that use that source. Unlike a typical worksheet filter, which is configured for a particular view unless applied more broadly, a data source filter establishes a restriction at the data source level.
For example, suppose a company has a dataset containing 100,000 sales records from multiple countries. If the business needs reports only for India, you can create a data source filter on the Country field and include India.
| Order ID | Country | Category | Sales |
|---|---|---|---|
| 1001 | India | Technology | ₹25,000 |
| 1002 | USA | Furniture | ₹18,000 |
| 1003 | India | Office Supplies | ₹12,000 |
| 1004 | UK | Technology | ₹30,000 |
| 1005 | India | Furniture | ₹20,000 |
If the Country filter includes only India, the available records will be:
| Order ID | Country | Category | Sales |
|---|---|---|---|
| 1001 | India | Technology | ₹25,000 |
| 1003 | India | Office Supplies | ₹12,000 |
| 1005 | India | Furniture | ₹20,000 |
The USA and UK records are excluded by this filter from analyses using the filtered data source.
| Basis | Data Source Filter | Worksheet Filter |
|---|---|---|
| Application level | At the data source level | At the worksheet/view level by default |
| Purpose | Restricts data available to analyses using the source | Controls which data appears in a particular view |
| Scope | Can affect multiple worksheets using the filtered source | Usually affects the current worksheet unless applied to other worksheets |
| Visibility | Not normally displayed as a filter card on the worksheet | Can be displayed as an interactive filter card |
| Typical example | Include only India records for a regional reporting source | Let viewers select a product category in a chart |
| Best use | Establish a shared restriction on available data | Explore or present different subsets in a view |
Note: The exact options may vary by Tableau version and connector. Tableau's official guide explains both ways to create data source filters: Filter Data from Data Sources — Tableau Help.
Imagine a sales analyst is preparing a report for the India business team. The original dataset includes sales records from four countries, but only Indian records are needed.
The analysis uses Indian sales records rather than the full international dataset. If the workbook contains multiple worksheets using this same filtered source, the restriction applies to those analyses as well.
Dimension filters commonly restrict text or categorical fields such as Country, Region, Category, Department, or Customer Segment.
Example: Include only the Technology and Furniture categories.
Date filters can restrict records to a particular date, range, or relative period.
Example: Include orders from the current financial year. Ensure that the date range matches the business's financial-year definition.
Numeric conditions can limit data using fields such as Quantity, Sales, Profit, or Discount, depending on the available field and filter options.
Example: Include records where Sales is greater than ₹10,000.
In data models with related tables, Tableau may allow a data source filter to apply only to the selected logical table or to that table and its related tables. Choose the scope carefully because it affects which related data is restricted.
These are related concepts, but they are not identical.
| Feature | Data Source Filter | Extract Filter |
|---|---|---|
| Main purpose | Restricts data available to analyses using the data source | Limits the data included when creating or refreshing an extract |
| Connection context | Can be used with supported live or extract data sources | Applies to extract-based data sources |
| Effect on data | Applies a restriction to queries and analysis using that source | Can reduce the rows stored in the extract |
| Typical example | Keep reports focused on India sales | Store only the required years of sales data in an extract |
Important: Do not assume that a data source filter always reduces the physical size of an extract. If reducing the extract itself is the goal, configure and verify the extract filter behavior for your data source and connection type.
When a data model includes multiple related logical tables, scope determines how widely a filter applies.
The available choices depend on the data model, field dependencies, and Tableau version. Some filters, such as calculations that reference multiple tables, may require a broader scope.
Practical tip: After adding a filter, test worksheets that use related tables to make sure the filter produces the expected results.
| Problem | Possible Cause | Solution |
|---|---|---|
| No records appear | The selected values or conditions exclude all records | Reopen the filter and verify the values and conditions |
| Some expected records are missing | The data source filter excludes those records | Review all active data source filters and their conditions |
| A related table behaves unexpectedly | The filter scope does not match the intended data model behavior | Review the table-only or table-and-related-tables scope |
| A worksheet does not show the filter card | Data source filters are not normally displayed as worksheet filter cards | Check the data source filter configuration rather than expecting a visible card |
| Performance does not improve | The connection or query plan may not benefit from the restriction | Test query performance and inspect the underlying data source |
| Published users can access unexpected data | Permissions or security configuration may be insufficient | Review published data source permissions and row-level security controls |
Task: Create a data source filter for a sales dataset so that only orders from the year 2025 and the country India are available to the analysis.
You should be able to create multiple data source filters, verify their combined effect, and explain how they differ from worksheet filters.
A data source filter restricts the data available to analyses using a particular data source.
They help restrict irrelevant data, maintain a common data scope across worksheets, and may improve performance in suitable environments.
Open the Data Source page and click Add in the Filters section, or right-click the data source in the Data pane and choose Edit Data Source Filters.
A data source filter restricts the data available to analyses using the source, while a worksheet filter normally controls the data displayed in a particular view.
Yes. Worksheets that use the same filtered data source are affected by its restrictions.
No. To reduce the data physically stored in an extract, check and configure the relevant extract filtering options.
They can help provide a restricted subset of data, particularly in published data sources. However, proper permissions and security controls are also important.
Scope controls whether a data source filter applies only to one logical table or to that table and its related tables.
Review active filters, selected values, date ranges, and the filter scope.
Refer to Tableau Help: Filter Data from Data Sources.
Filtering data at the data source level is an important Tableau skill for defining which records are available for analysis. By choosing the right fields, conditions, and scope, you can create more focused and consistent reports. Always verify the results across worksheets and use appropriate publishing permissions and security controls when working with restricted business data.
